﻿<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/Site.Master" CodeBehind="RatingReport.aspx.vb" Inherits="soccer.RatingReport" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
    <style type="text/css">
    .auto-style1 {
        font-size: medium;
    }
</style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="FeaturedContent" runat="server">
</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="MainContent" runat="server">
    <p class="auto-style1">
    <strong>Here are the average ratings for fixtures reported on this site</strong></p>
<p class="auto-style1">
    &nbsp;</p>
<p class="auto-style1">
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="AvgRateDataSource">
        <Columns>
            <asp:BoundField DataField="fixtureId" HeaderText="Fixture Id" SortExpression="fixtureId" />
            <asp:BoundField DataField="Team_1.teamName" HeaderText="Home Team" SortExpression="Team_1.teamName" />
            <asp:BoundField DataField="homeTeamScore" HeaderText="HomeTeam Score" SortExpression="homeTeamScore" />
            <asp:BoundField DataField="Team.teamName" HeaderText="Away Team" SortExpression="Team.teamName" />
            <asp:BoundField DataField="awayTeamScore" HeaderText="AwayTeam Score" SortExpression="awayTeamScore" />
            <asp:BoundField DataField="fixtureDate" HeaderText="Fixture Date" SortExpression="fixtureDate" />
            <asp:BoundField DataField="AverageRating" HeaderText="Average Rating" ReadOnly="True" SortExpression="AverageRating" />
        </Columns>
    </asp:GridView>
    <asp:SqlDataSource ID="AvgRateDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:SoccerConnectionString %>" ProviderName="<%$ ConnectionStrings:SoccerConnectionString.ProviderName %>" SelectCommand="SELECT * FROM [AvgRateQuery]"></asp:SqlDataSource>
</p>
<p class="auto-style1">
    <asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl="~/resultlist.aspx">Back to Results List</asp:HyperLink>
</p>
</asp:Content>
